Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 560844 |
| Missing cells | 2902243 |
| Missing cells (%) | 20.7% |
| Duplicate rows | 3864 |
| Duplicate rows (%) | 0.7% |
| Total size in memory | 103.2 MiB |
| Average record size in memory | 193.0 B |
Variable types
| CAT | 18 |
|---|---|
| DATE | 3 |
| NUM | 3 |
| BOOL | 1 |
Reproduction
| Analysis started | 2021-01-30 07:21:11.539317 |
|---|---|
| Analysis finished | 2021-01-30 07:22:05.863572 |
| Duration | 54.32 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
| Dataset has 3864 (0.7%) duplicate rows | Duplicates |
CLOSE-DT has a high cardinality: 4684 distinct values | High cardinality |
CREDIT-LIMIT/SANC AMT has a high cardinality: 877 distinct values | High cardinality |
DISBURSED-AMT/HIGH CREDIT has a high cardinality: 72426 distinct values | High cardinality |
INSTALLMENT-AMT has a high cardinality: 50133 distinct values | High cardinality |
CURRENT-BAL has a high cardinality: 147445 distinct values | High cardinality |
OVERDUE-AMT has a high cardinality: 22385 distinct values | High cardinality |
REPORTED DATE - HIST has a high cardinality: 57846 distinct values | High cardinality |
DPD - HIST has a high cardinality: 134338 distinct values | High cardinality |
CUR BAL - HIST has a high cardinality: 447072 distinct values | High cardinality |
AMT OVERDUE - HIST has a high cardinality: 187341 distinct values | High cardinality |
AMT PAID - HIST has a high cardinality: 83417 distinct values | High cardinality |
DISBURSED-DT has 32150 (5.7%) missing values | Missing |
CLOSE-DT has 251758 (44.9%) missing values | Missing |
LAST-PAYMENT-DATE has 319283 (56.9%) missing values | Missing |
CREDIT-LIMIT/SANC AMT has 545685 (97.3%) missing values | Missing |
INSTALLMENT-AMT has 420509 (75.0%) missing values | Missing |
INSTALLMENT-FREQUENCY has 425135 (75.8%) missing values | Missing |
OVERDUE-AMT has 118891 (21.2%) missing values | Missing |
WRITE-OFF-AMT has 19123 (3.4%) missing values | Missing |
ASSET_CLASS has 300376 (53.6%) missing values | Missing |
REPORTED DATE - HIST has 19123 (3.4%) missing values | Missing |
DPD - HIST has 19647 (3.5%) missing values | Missing |
CUR BAL - HIST has 19123 (3.4%) missing values | Missing |
AMT OVERDUE - HIST has 19123 (3.4%) missing values | Missing |
AMT PAID - HIST has 20294 (3.6%) missing values | Missing |
TENURE has 368107 (65.6%) missing values | Missing |
WRITE-OFF-AMT is highly skewed (γ1 = 283.4678315) | Skewed |
WRITE-OFF-AMT has 540655 (96.4%) zeros | Zeros |
TENURE has 18051 (3.2%) zeros | Zeros |
ID
Real number (ℝ≥0)
| Distinct count | 128655 |
|---|---|
| Unique (%) | 22.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 67401.69835997175 |
|---|---|
| Minimum | 1 |
| Maximum | 143395 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6329 |
| Q1 | 32434 |
| median | 61399 |
| Q3 | 101283.25 |
| 95-th percentile | 135844 |
| Maximum | 143395 |
| Range | 143394 |
| Interquartile range (IQR) | 68849.25 |
Descriptive statistics
| Standard deviation | 41016.1773 |
|---|---|
| Coefficient of variation (CV) | 0.6085332906 |
| Kurtosis | -1.146697158 |
| Mean | 67401.69836 |
| Median Absolute Deviation (MAD) | 33280 |
| Skewness | 0.2017691519 |
| Sum | 3.780183812e+10 |
| Variance | 1682326800 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 71060 | 420 | 0.1% | |
| 141732 | 165 | < 0.1% | |
| 51786 | 152 | < 0.1% | |
| 1167 | 138 | < 0.1% | |
| 97794 | 124 | < 0.1% | |
| 128175 | 120 | < 0.1% | |
| 28072 | 112 | < 0.1% | |
| 126242 | 105 | < 0.1% | |
| 54465 | 100 | < 0.1% | |
| 503 | 98 | < 0.1% | |
| Other values (128645) | 559310 | 99.7% |
| Value | Count | Frequency (%) | |
| 1 | 9 | < 0.1% | |
| 2 | 13 | < 0.1% | |
| 3 | 31 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 8 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 143395 | 1 | < 0.1% | |
| 143394 | 1 | < 0.1% | |
| 143393 | 4 | < 0.1% | |
| 143391 | 1 | < 0.1% | |
| 143390 | 2 | < 0.1% |
SELF-INDICATOR
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 547.7 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 396523 | 70.7% | |
| True | 164321 | 29.3% |
MATCH-TYPE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| PRIMARY | |
|---|---|
| SECONDARY | 197 |
| Value | Count | Frequency (%) | |
| PRIMARY | 560647 | > 99.9% | |
| SECONDARY | 197 | < 0.1% |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.000702513 |
| Min length | 7 |
ACCT-TYPE
Categorical
| Distinct count | 50 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| Tractor Loan | |
|---|---|
| Gold Loan | |
| Business Loan Priority Sector Agriculture | |
| Kisan Credit Card | 33369 |
| Auto Loan (Personal) | 29575 |
| Other values (45) |
| Value | Count | Frequency (%) | |
| Tractor Loan | 186242 | 33.2% | |
| Gold Loan | 91024 | 16.2% | |
| Business Loan Priority Sector Agriculture | 80084 | 14.3% | |
| Kisan Credit Card | 33369 | 5.9% | |
| Auto Loan (Personal) | 29575 | 5.3% | |
| Other | 27226 | 4.9% | |
| Commercial Vehicle Loan | 19522 | 3.5% | |
| Two-Wheeler Loan | 15805 | 2.8% | |
| Credit Card | 12702 | 2.3% | |
| Consumer Loan | 12124 | 2.2% | |
| Other values (40) | 53171 | 9.5% |
Length
| Max length | 67 |
|---|---|
| Median length | 12 |
| Mean length | 17.33400019 |
| Min length | 5 |
CONTRIBUTOR-TYPE
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| NBF | |
|---|---|
| NAB | |
| PRB | |
| RRB | 24023 |
| COP | 22201 |
| Other values (7) | 8537 |
| Value | Count | Frequency (%) | |
| NBF | 256835 | 45.8% | |
| NAB | 173895 | 31.0% | |
| PRB | 75353 | 13.4% | |
| RRB | 24023 | 4.3% | |
| COP | 22201 | 4.0% | |
| MFI | 3370 | 0.6% | |
| HFC | 2744 | 0.5% | |
| CCC | 1470 | 0.3% | |
| FRB | 755 | 0.1% | |
| SFB | 187 | < 0.1% | |
| Other values (2) | 11 | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
DATE-REPORTED
Date
| Distinct count | 2652 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 3683 |
| Missing (%) | 0.7% |
| Memory size | 4.3 MiB |
| Minimum | 2008-03-01 00:00:00 |
|---|---|
| Maximum | 2020-08-08 00:00:00 |
Histogram
OWNERSHIP-IND
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| Individual | |
|---|---|
| Joint | 37425 |
| Guarantor | 34876 |
| Primary | 4561 |
| Supl Card Holder | 138 |
| Value | Count | Frequency (%) | |
| Individual | 483844 | 86.3% | |
| Joint | 37425 | 6.7% | |
| Guarantor | 34876 | 6.2% | |
| Primary | 4561 | 0.8% | |
| Supl Card Holder | 138 | < 0.1% |
Length
| Max length | 16 |
|---|---|
| Median length | 10 |
| Mean length | 9.581245409 |
| Min length | 5 |
ACCOUNT-STATUS
Categorical
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| Closed | |
|---|---|
| Active | |
| Delinquent | 32457 |
| Written Off | 2937 |
| Suit Filed | 2062 |
| Other values (6) | 1236 |
| Value | Count | Frequency (%) | |
| Closed | 320255 | 57.1% | |
| Active | 201897 | 36.0% | |
| Delinquent | 32457 | 5.8% | |
| Written Off | 2937 | 0.5% | |
| Suit Filed | 2062 | 0.4% | |
| Settled | 626 | 0.1% | |
| Restructured | 511 | 0.1% | |
| SUIT FILED (WILFUL DEFAULT) | 70 | < 0.1% | |
| WILFUL DEFAULT | 27 | < 0.1% | |
| Sold/Purchased | 1 | < 0.1% |
Length
| Max length | 27 |
|---|---|
| Median length | 6 |
| Mean length | 6.281985722 |
| Min length | 6 |
| Distinct count | 6279 |
|---|---|
| Unique (%) | 1.2% |
| Missing | 32150 |
| Missing (%) | 5.7% |
| Memory size | 4.3 MiB |
| Minimum | 1900-01-02 00:00:00 |
|---|---|
| Maximum | 2020-02-11 00:00:00 |
Histogram
| Distinct count | 4684 |
|---|---|
| Unique (%) | 1.5% |
| Missing | 251758 |
| Missing (%) | 44.9% |
| Memory size | 4.3 MiB |
| 2019-06-01 00:00:00 | 701 |
|---|---|
| 2017-07-31 00:00:00 | 687 |
| 2018-03-31 00:00:00 | 656 |
| 2018-01-31 00:00:00 | 623 |
| 2017-10-31 00:00:00 | 578 |
| Other values (4679) |
| Value | Count | Frequency (%) | |
| 2019-06-01 00:00:00 | 701 | 0.1% | |
| 2017-07-31 00:00:00 | 687 | 0.1% | |
| 2018-03-31 00:00:00 | 656 | 0.1% | |
| 2018-01-31 00:00:00 | 623 | 0.1% | |
| 2017-10-31 00:00:00 | 578 | 0.1% | |
| 2015-07-01 00:00:00 | 575 | 0.1% | |
| 2017-06-30 00:00:00 | 558 | 0.1% | |
| 2016-06-30 00:00:00 | 534 | 0.1% | |
| 2016-03-31 00:00:00 | 531 | 0.1% | |
| 2017-03-31 00:00:00 | 496 | 0.1% | |
| Other values (4674) | 303147 | 54.1% | |
| (Missing) | 251758 | 44.9% |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 11.81773898 |
| Min length | 3 |
| Distinct count | 4085 |
|---|---|
| Unique (%) | 1.7% |
| Missing | 319283 |
| Missing (%) | 56.9% |
| Memory size | 4.3 MiB |
| Minimum | 1900-01-02 00:00:00 |
|---|---|
| Maximum | 2099-12-12 00:00:00 |
Histogram
| Distinct count | 877 |
|---|---|
| Unique (%) | 5.8% |
| Missing | 545685 |
| Missing (%) | 97.3% |
| Memory size | 4.3 MiB |
| 0 | |
|---|---|
| 30,000 | 917 |
| 25,000 | 881 |
| 15,000 | 706 |
| 10,000 | 572 |
| Other values (872) |
| Value | Count | Frequency (%) | |
| 0 | 4624 | 0.8% | |
| 30,000 | 917 | 0.2% | |
| 25,000 | 881 | 0.2% | |
| 15,000 | 706 | 0.1% | |
| 10,000 | 572 | 0.1% | |
| 50,000 | 549 | 0.1% | |
| 20,000 | 539 | 0.1% | |
| 40,000 | 346 | 0.1% | |
| 60,000 | 214 | < 0.1% | |
| 1,00,000 | 204 | < 0.1% | |
| Other values (867) | 5607 | 1.0% | |
| (Missing) | 545685 | 97.3% |
Length
| Max length | 9 |
|---|---|
| Median length | 3 |
| Mean length | 3.044079994 |
| Min length | 1 |
| Distinct count | 72426 |
|---|---|
| Unique (%) | 12.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| 0 | 32049 |
|---|---|
| 3,00,000 | 25150 |
| 2,00,000 | 15784 |
| 2,50,000 | 13091 |
| 4,00,000 | 13059 |
| Other values (72421) |
| Value | Count | Frequency (%) | |
| 0 | 32049 | 5.7% | |
| 3,00,000 | 25150 | 4.5% | |
| 2,00,000 | 15784 | 2.8% | |
| 2,50,000 | 13091 | 2.3% | |
| 4,00,000 | 13059 | 2.3% | |
| 1,00,000 | 12817 | 2.3% | |
| 3,50,000 | 11872 | 2.1% | |
| 50,000 | 9291 | 1.7% | |
| 1,50,000 | 8148 | 1.5% | |
| 5,00,000 | 7284 | 1.3% | |
| Other values (72416) | 412299 | 73.5% |
Length
| Max length | 12 |
|---|---|
| Median length | 8 |
| Mean length | 6.995494291 |
| Min length | 1 |
| Distinct count | 50133 |
|---|---|
| Unique (%) | 35.7% |
| Missing | 420509 |
| Missing (%) | 75.0% |
| Memory size | 4.3 MiB |
| 0/Monthly | |
|---|---|
| 0 | 1934 |
| 1,00,000/Monthly | 1735 |
| 50,000/Monthly | 793 |
| 40,000/Monthly | 623 |
| Other values (50128) |
| Value | Count | Frequency (%) | |
| 0/Monthly | 28606 | 5.1% | |
| 0 | 1934 | 0.3% | |
| 1,00,000/Monthly | 1735 | 0.3% | |
| 50,000/Monthly | 793 | 0.1% | |
| 40,000/Monthly | 623 | 0.1% | |
| 60,000/Monthly | 507 | 0.1% | |
| 30,000/Monthly | 496 | 0.1% | |
| 10,000/Monthly | 493 | 0.1% | |
| 1,0,000/Monthly | 475 | 0.1% | |
| 20,000/Monthly | 452 | 0.1% | |
| Other values (50123) | 104221 | 18.6% | |
| (Missing) | 420509 | 75.0% |
Length
| Max length | 46 |
|---|---|
| Median length | 3 |
| Mean length | 5.452630321 |
| Min length | 1 |
| Distinct count | 147445 |
|---|---|
| Unique (%) | 26.3% |
| Missing | 233 |
| Missing (%) | < 0.1% |
| Memory size | 4.3 MiB |
| 0 | |
|---|---|
| 2,50,000 | 760 |
| 1,00,000 | 427 |
| 3,00,000 | 389 |
| 50,000 | 356 |
| Other values (147440) |
| Value | Count | Frequency (%) | |
| 0 | 353347 | 63.0% | |
| 2,50,000 | 760 | 0.1% | |
| 1,00,000 | 427 | 0.1% | |
| 3,00,000 | 389 | 0.1% | |
| 50,000 | 356 | 0.1% | |
| 1,50,000 | 318 | 0.1% | |
| 2,00,000 | 291 | 0.1% | |
| 3,50,000 | 269 | < 0.1% | |
| 60,000 | 207 | < 0.1% | |
| 40,000 | 203 | < 0.1% | |
| Other values (147435) | 204044 | 36.4% | |
| (Missing) | 233 | < 0.1% |
Length
| Max length | 12 |
|---|---|
| Median length | 1 |
| Mean length | 3.268782407 |
| Min length | 1 |
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 425135 |
| Missing (%) | 75.8% |
| Memory size | 4.3 MiB |
| F03 | |
|---|---|
| F01 | 2377 |
| F05 | 2334 |
| F02 | 1778 |
| F10 | 305 |
| Other values (4) | 27 |
| Value | Count | Frequency (%) | |
| F03 | 128888 | 23.0% | |
| F01 | 2377 | 0.4% | |
| F05 | 2334 | 0.4% | |
| F02 | 1778 | 0.3% | |
| F10 | 305 | 0.1% | |
| F04 | 13 | < 0.1% | |
| F07 | 7 | < 0.1% | |
| F08 | 6 | < 0.1% | |
| F06 | 1 | < 0.1% | |
| (Missing) | 425135 | 75.8% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 22385 |
|---|---|
| Unique (%) | 5.1% |
| Missing | 118891 |
| Missing (%) | 21.2% |
| Memory size | 4.3 MiB |
| 0 | |
|---|---|
| 118 | 271 |
| 1 | 145 |
| 100 | 89 |
| 236 | 61 |
| Other values (22380) | 32954 |
| Value | Count | Frequency (%) | |
| 0 | 408433 | 72.8% | |
| 118 | 271 | < 0.1% | |
| 1 | 145 | < 0.1% | |
| 100 | 89 | < 0.1% | |
| 236 | 61 | < 0.1% | |
| 119 | 53 | < 0.1% | |
| 5 | 34 | < 0.1% | |
| 2 | 32 | < 0.1% | |
| 500 | 31 | < 0.1% | |
| 10,000 | 30 | < 0.1% | |
| Other values (22375) | 32774 | 5.8% | |
| (Missing) | 118891 | 21.2% |
Length
| Max length | 11 |
|---|---|
| Median length | 1 |
| Mean length | 1.697939177 |
| Min length | 1 |
| Distinct count | 1009 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 19123 |
| Missing (%) | 3.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 295.631911998981 |
|---|---|
| Minimum | -30.0 |
| Maximum | 8797356.0 |
| Zeros | 540655 |
| Zeros (%) | 96.4% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | -30 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 8797356 |
| Range | 8797386 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 19501.65161 |
|---|---|
| Coefficient of variation (CV) | 65.96598952 |
| Kurtosis | 110574.922 |
| Mean | 295.631912 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 283.4678315 |
| Sum | 160150015 |
| Variance | 380314415.4 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 540655 | 96.4% | |
| 352886 | 9 | < 0.1% | |
| 143614 | 4 | < 0.1% | |
| 23056 | 3 | < 0.1% | |
| 53682 | 3 | < 0.1% | |
| 238 | 3 | < 0.1% | |
| 184310 | 2 | < 0.1% | |
| 85 | 2 | < 0.1% | |
| 7574 | 2 | < 0.1% | |
| 142290 | 2 | < 0.1% | |
| Other values (999) | 1036 | 0.2% | |
| (Missing) | 19123 | 3.4% |
| Value | Count | Frequency (%) | |
| -30 | 1 | < 0.1% | |
| 0 | 540655 | 96.4% | |
| 1 | 2 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8797356 | 1 | < 0.1% | |
| 7000000 | 1 | < 0.1% | |
| 3616312 | 1 | < 0.1% | |
| 2400000 | 1 | < 0.1% | |
| 2095311 | 1 | < 0.1% |
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 300376 |
| Missing (%) | 53.6% |
| Memory size | 4.3 MiB |
| Standard | |
|---|---|
| SubStandard | 5300 |
| Doubtful | 2578 |
| Special Mention Account | 2505 |
| Loss | 873 |
| Other values (3) | 542 |
| Value | Count | Frequency (%) | |
| Standard | 248670 | 44.3% | |
| SubStandard | 5300 | 0.9% | |
| Doubtful | 2578 | 0.5% | |
| Special Mention Account | 2505 | 0.4% | |
| Loss | 873 | 0.2% | |
| 1 | 362 | 0.1% | |
| 01 | 177 | < 0.1% | |
| 2 | 3 | < 0.1% | |
| (Missing) | 300376 | 53.6% |
Length
| Max length | 23 |
|---|---|
| Median length | 3 |
| Mean length | 5.404779226 |
| Min length | 1 |
| Distinct count | 57846 |
|---|---|
| Unique (%) | 10.7% |
| Missing | 19123 |
| Missing (%) | 3.4% |
| Memory size | 4.3 MiB |
| 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180930,20180831,20180731,20180630,20180531,20180430,20180331,20180228,20180131,20171231,20171130,20171031,20170930,20170831,20170731,20170630,20170531,20170430,20170331,20170228, | 25369 |
|---|---|
| 20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180930,20180831,20180731,20180630,20180531,20180430,20180331,20180228,20180131,20171231,20171130,20171031,20170930,20170831,20170731,20170630,20170531,20170430,20170331,20170228,20170131, | 6699 |
| 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180930,20180831,20180731,20180630,20180531,20180430,20180331,20180228,20180131,20171231,20171130,20171031,20170930,20170831,20170731,20170630, | 3480 |
| 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180930,20180831,20180731,20180630,20180531,20180430,20180331,20180228,20180131,20171231,20171130,20171031, | 2923 |
| 20200131, | 2881 |
| Other values (57841) |
| Value | Count | Frequency (%) | |
| 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180930,20180831,20180731,20180630,20180531,20180430,20180331,20180228,20180131,20171231,20171130,20171031,20170930,20170831,20170731,20170630,20170531,20170430,20170331,20170228, | 25369 | 4.5% | |
| 20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180930,20180831,20180731,20180630,20180531,20180430,20180331,20180228,20180131,20171231,20171130,20171031,20170930,20170831,20170731,20170630,20170531,20170430,20170331,20170228,20170131, | 6699 | 1.2% | |
| 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180930,20180831,20180731,20180630,20180531,20180430,20180331,20180228,20180131,20171231,20171130,20171031,20170930,20170831,20170731,20170630, | 3480 | 0.6% | |
| 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180930,20180831,20180731,20180630,20180531,20180430,20180331,20180228,20180131,20171231,20171130,20171031, | 2923 | 0.5% | |
| 20200131, | 2881 | 0.5% | |
| 20200131,20191231,20191130, | 2836 | 0.5% | |
| 20200131,20191231, | 2689 | 0.5% | |
| 20190831,20190820, | 2514 | 0.4% | |
| 20200131,20191231,20191130,20191031, | 2314 | 0.4% | |
| 20200131,20191231,20191130,20191031,20190930, | 2293 | 0.4% | |
| Other values (57836) | 487723 | 87.0% | |
| (Missing) | 19123 | 3.4% |
Length
| Max length | 324 |
|---|---|
| Median length | 162 |
| Mean length | 174.0041455 |
| Min length | 3 |
| Distinct count | 134338 |
|---|---|
| Unique (%) | 24.8% |
| Missing | 19647 |
| Missing (%) | 3.5% |
| Memory size | 4.3 MiB |
| 0 | 43756 |
|---|---|
| XXX | 39096 |
| 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | 22330 |
| XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | 10778 |
| 000 | 7369 |
| Other values (134333) |
| Value | Count | Frequency (%) | |
| 0 | 43756 | 7.8% | |
| XXX | 39096 | 7.0% | |
| 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | 22330 | 4.0% | |
| XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | 10778 | 1.9% | |
| 000 | 7369 | 1.3% | |
| XXXXXX | 7219 | 1.3% | |
| 000DDD000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | 5980 | 1.1% | |
| XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | 5540 | 1.0% | |
| 000000 | 4766 | 0.8% | |
| 000000000000 | 4368 | 0.8% | |
| Other values (134328) | 389995 | 69.5% | |
| (Missing) | 19647 | 3.5% |
Length
| Max length | 108 |
|---|---|
| Median length | 45 |
| Mean length | 52.22108643 |
| Min length | 1 |
| Distinct count | 447072 |
|---|---|
| Unique (%) | 82.5% |
| Missing | 19123 |
| Missing (%) | 3.4% |
| Memory size | 4.3 MiB |
| , | 31827 |
|---|---|
| 0, | 9182 |
| 0,0, | 2428 |
| 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, | 2039 |
| 0,0,,,,,,,,,,,,,0,0, | 518 |
| Other values (447067) |
| Value | Count | Frequency (%) | |
| , | 31827 | 5.7% | |
| 0, | 9182 | 1.6% | |
| 0,0, | 2428 | 0.4% | |
| 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, | 2039 | 0.4% | |
| 0,0,,,,,,,,,,,,,0,0, | 518 | 0.1% | |
| 0,0,0, | 422 | 0.1% | |
| 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, | 315 | 0.1% | |
| 250000,250000,250000, | 275 | < 0.1% | |
| 0,0,0,,,,,,,,,,,,,0, | 247 | < 0.1% | |
| 0,0,0,0,0,0,0, | 222 | < 0.1% | |
| Other values (447062) | 494246 | 88.1% | |
| (Missing) | 19123 | 3.4% |
Length
| Max length | 357 |
|---|---|
| Median length | 100 |
| Mean length | 115.1796168 |
| Min length | 1 |
| Distinct count | 187341 |
|---|---|
| Unique (%) | 34.6% |
| Missing | 19123 |
| Missing (%) | 3.4% |
| Memory size | 4.3 MiB |
| , | 35378 |
|---|---|
| 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 | 14323 |
| ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | 11116 |
| 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, | 10319 |
| 0, | 9245 |
| Other values (187336) |
| Value | Count | Frequency (%) | |
| , | 35378 | 6.3% | |
| 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 | 14323 | 2.6% | |
| ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | 11116 | 2.0% | |
| 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, | 10319 | 1.8% | |
| 0, | 9245 | 1.6% | |
| 0,0, | 7977 | 1.4% | |
| 0,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 | 5993 | 1.1% | |
| 0 | 5644 | 1.0% | |
| ,,,,,,,,,,,,, | 5130 | 0.9% | |
| 0,0,0,0,0,0,0,0,0,0,0,0,0 | 4626 | 0.8% | |
| Other values (187331) | 431970 | 77.0% | |
| (Missing) | 19123 | 3.4% |
Length
| Max length | 291 |
|---|---|
| Median length | 36 |
| Mean length | 43.03493841 |
| Min length | 1 |
| Distinct count | 83417 |
|---|---|
| Unique (%) | 15.4% |
| Missing | 20294 |
| Missing (%) | 3.6% |
| Memory size | 4.3 MiB |
| ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | 63203 |
|---|---|
| ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | 44600 |
| , | 41773 |
| ,,,,,,,,,,,,,, | 13911 |
| ,, | 11439 |
| Other values (83412) |
| Value | Count | Frequency (%) | |
| ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | 63203 | 11.3% | |
| ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | 44600 | 8.0% | |
| , | 41773 | 7.4% | |
| ,,,,,,,,,,,,,, | 13911 | 2.5% | |
| ,, | 11439 | 2.0% | |
| ,,,,,,,,,,,,, | 10526 | 1.9% | |
| ,,,,,,,,,,,,,,, | 10318 | 1.8% | |
| ,,, | 9692 | 1.7% | |
| ,,,,,,,,,,,, | 8824 | 1.6% | |
| ,,,,,, | 8803 | 1.6% | |
| Other values (83407) | 317461 | 56.6% | |
| (Missing) | 20294 | 3.6% |
Length
| Max length | 308 |
|---|---|
| Median length | 23 |
| Mean length | 27.71264558 |
| Min length | 1 |
| Distinct count | 324 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 368107 |
| Missing (%) | 65.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.801029382007606 |
|---|---|
| Minimum | 0.0 |
| Maximum | 856.0 |
| Zeros | 18051 |
| Zeros (%) | 3.2% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 12 |
| median | 23 |
| Q3 | 36 |
| 95-th percentile | 72 |
| Maximum | 856 |
| Range | 856 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 32.17097453 |
|---|---|
| Coefficient of variation (CV) | 1.117007802 |
| Kurtosis | 33.20228367 |
| Mean | 28.80102938 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 4.098092905 |
| Sum | 5551024 |
| Variance | 1034.971602 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 12 | 47891 | 8.5% | |
| 36 | 27102 | 4.8% | |
| 0 | 18051 | 3.2% | |
| 60 | 13844 | 2.5% | |
| 24 | 11632 | 2.1% | |
| 48 | 7135 | 1.3% | |
| 1 | 5088 | 0.9% | |
| 30 | 5047 | 0.9% | |
| 6 | 4225 | 0.8% | |
| 18 | 3384 | 0.6% | |
| Other values (314) | 49338 | 8.8% | |
| (Missing) | 368107 | 65.6% |
| Value | Count | Frequency (%) | |
| 0 | 18051 | 3.2% | |
| 1 | 5088 | 0.9% | |
| 2 | 394 | 0.1% | |
| 3 | 550 | 0.1% | |
| 4 | 1629 | 0.3% |
| Value | Count | Frequency (%) | |
| 856 | 2 | < 0.1% | |
| 752 | 1 | < 0.1% | |
| 745 | 2 | < 0.1% | |
| 704 | 1 | < 0.1% | |
| 670 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| ID | SELF-INDICATOR | MATCH-TYPE | ACCT-TYPE | CONTRIBUTOR-TYPE | DATE-REPORTED | OWNERSHIP-IND | ACCOUNT-STATUS | DISBURSED-DT | CLOSE-DT | LAST-PAYMENT-DATE | CREDIT-LIMIT/SANC AMT | DISBURSED-AMT/HIGH CREDIT | INSTALLMENT-AMT | CURRENT-BAL | INSTALLMENT-FREQUENCY | OVERDUE-AMT | WRITE-OFF-AMT | ASSET_CLASS | REPORTED DATE - HIST | DPD - HIST | CUR BAL - HIST | AMT OVERDUE - HIST | AMT PAID - HIST | TENURE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | False | PRIMARY | Overdraft | NAB | 2018-04-30 | Individual | Delinquent | 2015-10-05 | NaN | 2018-02-27 | NaN | 37,352 | NaN | 37,873 | NaN | 37,873 | 0.0 | Standard | 20180430,20180331, | 030000 | 37873,12820, | 37873,, | ,, | NaN |
| 1 | 1 | False | PRIMARY | Auto Loan (Personal) | NAB | 2019-12-31 | Individual | Active | 2018-03-19 | NaN | 2019-12-19 | NaN | 44,000 | 1,405/Monthly | 20,797 | F03 | NaN | 0.0 | Standard | 20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180930,20180831,20180731,20180630,20180531,20180430,20180331, | 000000000000000000000000000000000000000000000000000000000000011000 | 20797,21988,23174,24341,25504,26648,27780,28910,30020,31128,32267,33427,34547,35655,36764,37850,38939,40004,41059,42118,44601,44181, | ,,,,,,,,,,,,,,,,,,,,1452,, | ,,,,,,,,,,,,,,,,,,,,,, | 36.0 |
| 2 | 1 | True | PRIMARY | Tractor Loan | NBF | 2020-01-31 | Individual | Active | 2019-08-30 | NaN | NaT | NaN | 1,45,000 | NaN | 1,16,087 | NaN | 0 | 0.0 | NaN | 20200131,20191231,20191130,20191031,20190930,20190831, | 000000000000000000 | 116087,116087,145000,145000,145000,145000, | 0,0,0,0,0,0, | ,,,,,, | NaN |
| 3 | 1 | True | PRIMARY | Auto Loan (Personal) | NBF | 2017-09-30 | Individual | Closed | 2013-09-27 | 2017-09-21 00:00:00 | NaT | NaN | 3,00,000 | NaN | 0 | NaN | 0 | 0.0 | NaN | 20170930,20170801,20170731,20170630,20170531,20170430,20170331,20170228,20170131,20161231,20161130,20161031,20160930,20160831,20160731,20160630,20160531,20160430,20160331,20160229,20160131,20151231,20151130,20151031,20150930,20150831,20150731,20150630,20150531,20150430,20150331,20150228,20150131,20141231,20141130,20141031, | 000DDD027026027026027024027027000032000000000000000026027025027027026027026027027026027000000000000000000000 | 0,,15925,23754,31494,39147,46713,54194,61590,68903,68903,76133,83281,90348,97336,104245,111076,124506,131108,137635,144088,150468,156776,163013,169180,175277,181305,187265,193157,198983,204743,210438,216069,221636,227140,232582, | 0,,1014,1014,1014,1014,1014,1014,1014,983,0,927,0,0,0,0,0,778,754,734,712,691,671,651,633,615,597,580,565,0,0,0,0,0,0,0 | ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | NaN |
| 4 | 1 | True | PRIMARY | Tractor Loan | NBF | 2016-02-29 | Individual | Closed | 2012-02-10 | 2016-02-01 00:00:00 | NaT | NaN | 2,75,000 | NaN | 0 | NaN | 0 | 0.0 | NaN | 20160229,20160131,20151231,20151130,20151031,20150930,20150831,20150731,20150630,20150531,20150430,20150331,20150228,20150131,20141231,20141130,20141031,20140930,20140831,20140731,20140630,20140531,20140430,20140331,20140228,20140131,20131231,20131130,20131031,20130930,20130831,20130731,20130630,20130531,20130430,20130331, | 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | 0,0,23658,23321,22989,46321,45662,45012,68030,67062,66108,88826,87562,86316,108747,107200,105675,127830,126012,124219,146111,144033,141984,163623,161295,159001,180398,177832,175302,196467,193672,190917,211860,208846,205875,226605, | 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 | ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | NaN |
| 5 | 1 | False | PRIMARY | Credit Card | NAB | 2018-04-30 | Individual | Closed | 2018-01-11 | 2018-03-13 00:00:00 | NaT | 50,000 | 0 | NaN | 0 | NaN | NaN | 0.0 | Standard | 20180331,20180228,20180131, | 000000000 | 24650,17300,0, | ,,, | ,,,, | NaN |
| 6 | 1 | False | PRIMARY | Auto Loan (Personal) | NAB | 2019-12-31 | Individual | Active | 2018-11-15 | NaN | 2019-12-15 | NaN | 5,00,000 | 7,934/Monthly | 4,43,769 | F03 | NaN | 0.0 | Standard | 20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130, | 000000000000000000000000000000000000000000 | 443769,448365,453134,457687,462320,466802,471249,475779,480157,484620,488928,493570,497810,502016, | ,,,,,,,,,,,,,, | ,,,,,,,,,,,,,, | 84.0 |
| 7 | 1 | True | PRIMARY | Auto Loan (Personal) | NBF | 2017-09-30 | Individual | Closed | 2013-01-30 | 2017-09-21 00:00:00 | NaT | NaN | 5,00,000 | NaN | 0 | NaN | 0 | 0.0 | NaN | 20170930,20170801,20170731,20170630,20170531,20170430,20170331,20170228,20170131,20161231,20161130,20161031,20160930,20160831,20160731,20160630,20160531,20160430,20160331,20160229,20160131,20151231,20151130,20151031,20150930,20150831,20150731,20150630,20150531,20150430,20150331,20150228,20150131,20141231,20141130,20141031, | 000DDD000000000000087054027027000032000000000000000026027025027027026027026027027026027026027024027027026027 | 0,,0,0,0,0,0,0,0,13060,13060,25982,38767,51417,63933,76317,88570,112688,124556,136299,147917,159413,170787,182041,193176,204193,215093,225878,236549,247107,257553,267889,278115,288233,298244,308149, | 0,,0,0,0,0,3064,3064,3064,2972,0,2802,0,0,0,0,0,2350,2278,2216,2151,2087,2028,1968,1914,1663,1128,1097,1064,1034,1001,976,947,918,893,866 | ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | NaN |
| 8 | 1 | True | PRIMARY | Auto Loan (Personal) | NBF | 2017-07-31 | Individual | Closed | 2013-06-11 | 2017-07-01 00:00:00 | NaT | NaN | 4,00,000 | NaN | 0 | NaN | 0 | 0.0 | NaN | 20170731,20170601,20170531,20170430,20170331,20170228,20170131,20161231,20161130,20161031,20160930,20160831,20160731,20160630,20160531,20160430,20160331,20160229,20160131,20151231,20151130,20151031,20150930,20150831,20150731,20150630,20150531,20150430,20150331,20150228,20150131,20141231,20141130,20141031,20140930,20140831, | 000DDD022021022019022022000027000000000000000021022020022022021022021022022021022021022019022022021022021022 | 0,,0,10487,20862,31126,41281,51328,51328,71101,71101,80830,90455,99978,109398,127940,137062,146088,155017,163851,172591,181237,189791,198254,206627,214911,223106,231214,239235,247171,255022,262790,270475,278077,285599,293040, | 0,,1722,1722,1722,1722,1722,1722,0,1625,0,0,0,0,0,1364,1321,1286,1249,1213,1179,1144,1113,1081,1048,1019,988,961,930,906,880,854,830,806,783,760 | ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | NaN |
| 9 | 2 | False | PRIMARY | Overdraft | PRB | 2017-03-31 | Individual | Closed | 2016-01-15 | 2017-03-27 00:00:00 | 2017-03-27 | NaN | 17,00,000 | NaN | 0 | NaN | 0 | 0.0 | NaN | 20170331,20170201,20170101,20161231,20161101,20161001,20160930,20160801,20160701,20160630,20160501,20160401,20160331, | 000DDDDDD000DDDDDD000DDDDDD000DDDDDD000 | 0,,,1699997,,,154997,,,-3,,,149997, | 0,,,0,,,0,,,0,,,0 | ,,,,,,,,,,,,,, | NaN |
Last rows
| ID | SELF-INDICATOR | MATCH-TYPE | ACCT-TYPE | CONTRIBUTOR-TYPE | DATE-REPORTED | OWNERSHIP-IND | ACCOUNT-STATUS | DISBURSED-DT | CLOSE-DT | LAST-PAYMENT-DATE | CREDIT-LIMIT/SANC AMT | DISBURSED-AMT/HIGH CREDIT | INSTALLMENT-AMT | CURRENT-BAL | INSTALLMENT-FREQUENCY | OVERDUE-AMT | WRITE-OFF-AMT | ASSET_CLASS | REPORTED DATE - HIST | DPD - HIST | CUR BAL - HIST | AMT OVERDUE - HIST | AMT PAID - HIST | TENURE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 560834 | 143389 | False | PRIMARY | Two-Wheeler Loan | NBF | 2018-09-01 | Individual | Closed | 2016-06-30 | 2018-07-03 00:00:00 | 2018-07-03 | NaN | 58,000 | NaN | 0 | NaN | NaN | 0.0 | NaN | 20180701,20180602,20180501,20180401,20180302,20180202,20180104,20171201,20171101,20171001,20170901,20170801,20170703,20170601,20170501,20170403,20170301,20170202,20170103,20161202,20161104,20161005,20160905,20160803,20160705, | DDD000DDD000000000000000000000000000000000DDD000DDD000000000000000000000000 | ,,5984,,11968,14960,17952,17952,23936,26928,29920,32912,35904,35904,41888,,44880,,53856,53856,59840,59840,62832,65824,68816,71808, | ,,0,,0,0,0,0,0,0,0,0,0,0,0,,0,,0,0,0,0,0,0,0,0 | ,,,,,,,,,,,,,,,,,,,,,,,,,, | NaN |
| 560835 | 143390 | True | PRIMARY | Tractor Loan | NBF | 2020-01-31 | Individual | Active | 2018-09-21 | NaN | NaT | NaN | 2,65,601 | NaN | 71,057 | NaN | 0 | 0.0 | NaN | 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180930, | 000000000000000000000000000000000000000000000000000 | 71057,71057,136800,136800,136800,136800,136800,136800,197627,197627,197627,197627,197627,197627,265601,265601,265601, | 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, | ,,,,,,,,,,,,,,,,, | NaN |
| 560836 | 143390 | False | PRIMARY | Property Loan | PRB | 2019-12-31 | Individual | Active | 2019-08-31 | NaN | 2019-12-09 | NaN | 18,22,000 | NaN | 17,96,573 | NaN | 0 | 0.0 | NaN | 20191231,20191130,20191031,20190930, | 000000000000 | 1796573,1805126,1813602,1822000, | 0,0,0,0, | ,,,, | 121.0 |
| 560837 | 143391 | True | PRIMARY | Tractor Loan | NBF | 2020-01-31 | Individual | Active | 2018-09-22 | NaN | NaT | NaN | 2,75,630 | NaN | 73,890 | NaN | 0 | 0.0 | NaN | 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180930, | 000000000000000000000000000000000000000000000000000 | 73890,73890,142050,142050,142050,142050,142050,142050,204926,204926,204926,204926,204926,204926,275630,275630,275630, | 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, | ,,,,,,,,,,,,,,,,, | NaN |
| 560838 | 143393 | True | PRIMARY | Tractor Loan | NBF | 2020-01-31 | Individual | Active | 2018-11-23 | NaN | NaT | NaN | 3,0,733 | NaN | 1,42,446 | NaN | 0 | 0.0 | NaN | 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130, | 0 | 142446,155709,168804,181731,194494,207093,207093,231812,243935,255903,267719,279384,290900,300733,300733, | 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, | ,,,,,,,,,,,,,,, | NaN |
| 560839 | 143393 | False | PRIMARY | Tractor Loan | NBF | 2019-12-31 | Individual | Closed | NaT | NaN | NaT | NaN | 2,50,000 | NaN | 0 | NaN | 0 | 0.0 | Standard | 20171231,20171130,20171001,20170930,20170831,20170731,20170630,20170531,20170430,20170331,20170228,20170131, | 000000DDD054024024000000000000000000 | 0,0,,67747,89638,111197,109562,130470,151135,171412,191662,211323, | 0,0,,22920,22920,22920,0,0,0,0,0,0 | ,,,,,,,,,,,,, | 12.0 |
| 560840 | 143393 | False | PRIMARY | Tractor Loan | NBF | 2019-12-31 | Individual | Active | 2017-10-31 | NaN | NaT | NaN | 3,0,000 | NaN | 0 | NaN | 0 | 0.0 | Standard | 20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190301,20190228,20190131,20181201,20181130,20181031,20180930,20180801,20180701,20180630,20180501,20180430,20180331,20180228,20180131,20171231,20171130, | 000000000000000000027028028DDD026030DDD000000000DDDDDD000DDD000000000000000000 | 0,0,14208,28265,42149,55874,69591,83001,96293,,122484,135286,,160108,172497,184813,,,220795,,244136,255560,267150,278310,289342,300000, | 0,0,0,0,0,0,125,125,125,,125,125,,0,0,0,,,0,,0,0,0,0,0,0, | ,,,,,,,,,,,,,,,,,,,,,,,,,, | 24.0 |
| 560841 | 143393 | False | PRIMARY | Auto Loan (Personal) | NBF | 2020-01-31 | Guarantor | Active | 2016-11-28 | NaN | 2020-01-16 | NaN | 3,93,819 | NaN | 1,1,687 | NaN | NaN | 0.0 | Standard | 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231,20181130,20181031,20180901,20180831,20180731,20180630,20180531,20180430,20180331,20180228,20180131,20171231,20171130,20171031,20170930,20170831,20170731,20170630,20170531,20170430,20170331,20170228, | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX031XXXXXX031DDD031061030XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | 101687,111161,120514,129749,138867,147870,156759,165535,174199,182754,191201,199540,207774,215904,223931,231855,,247405,255033,262564,269999,277341,284589,291745,298811,305787,312675,319476,326190,332820,339365,345828,352208,358508,364728,370869, | ,,,,,,,,,,,,10897,,,10763,,10771,21785,10885,,,,,,,,,,,,,,,,, | ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | 48.0 |
| 560842 | 143394 | True | PRIMARY | Tractor Loan | NBF | 2020-01-31 | Individual | Active | 2018-12-20 | NaN | NaT | NaN | 2,50,643 | NaN | 1,32,487 | NaN | 0 | 0.0 | NaN | 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231, | 0 | 132487,132487,132487,191426,191426,191426,191426,191426,191426,250643,250643,250643,250643,250643, | 0,0,0,0,0,0,0,0,0,0,0,0,0,0, | ,,,,,,,,,,,,,, | NaN |
| 560843 | 143395 | True | PRIMARY | Tractor Loan | NBF | 2020-01-31 | Individual | Active | 2018-12-31 | NaN | NaT | NaN | 2,0,428 | NaN | 1,5,499 | NaN | 0 | 0.0 | NaN | 20200131,20191231,20191130,20191031,20190930,20190831,20190731,20190630,20190531,20190430,20190331,20190228,20190131,20181231, | 0 | 105499,105499,105499,152431,152431,152431,152431,152431,152431,200428,200428,200428,200428,200428, | 0,0,0,0,0,0,0,0,0,0,0,0,0,0, | ,,,,,,,,,,,,,, | NaN |